/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:15:40
*/


-- ----------------------------
-- Table structure for tb2555
-- ----------------------------
DROP TABLE [dbo].[tb2555]
GO
CREATE TABLE [dbo].[tb2555] (
[EmployeeID] varchar(20) NOT NULL ,
[DivisionID] varchar(20) NULL ,
[FatherName] varchar(50) NULL ,
[FatherYear] int NULL ,
[FatherJob] nvarchar(250) NULL ,
[FatherAddress] nvarchar(250) NULL ,
[FatherNote] nvarchar(250) NULL ,
[IsFatherDeath] tinyint NOT NULL DEFAULT ((0)) ,
[MotherName] varchar(50) NULL ,
[MotherYear] int NULL ,
[MotherJob] nvarchar(250) NULL ,
[MotherAddress] nvarchar(250) NULL ,
[MotherNote] nvarchar(250) NULL ,
[IsMotherDeath] tinyint NOT NULL DEFAULT ((0)) ,
[SpouseName] varchar(50) NULL ,
[SpouseYear] int NULL ,
[SpouseAddress] nvarchar(250) NULL ,
[SpouseNote] nvarchar(250) NULL ,
[SpouseJob] nvarchar(250) NULL ,
[IsSpouseDeath] tinyint NOT NULL DEFAULT ((0)) ,
[EducationLevelID] varchar(20) NULL ,
[PoliticsID] varchar(20) NULL ,
[Language1ID] varchar(20) NULL ,
[Language2ID] varchar(20) NULL ,
[Language3ID] varchar(20) NULL ,
[LanguageLevel1ID] varchar(20) NULL ,
[LanguageLevel2ID] varchar(20) NULL ,
[LanguageLevel3ID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb2555
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb2555
-- ----------------------------
ALTER TABLE [dbo].[tb2555] ADD PRIMARY KEY NONCLUSTERED ([EmployeeID])
GO
